CREATE TABLE [dbo].[CartEventFunction]
(
[CartEventFunctionID] [int] NOT NULL IDENTITY(1, 1),
[CartEventID] [int] NOT NULL,
[FunctionCode] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity] [int] NOT NULL,
[Title] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Price] [money] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CartEventFunction] ADD CONSTRAINT [PK_CartEventFunction] PRIMARY KEY CLUSTERED ([CartEventFunctionID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CartEventFunction_CartEventID] ON [dbo].[CartEventFunction] ([CartEventID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[CartEventFunction] ([FunctionCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CartEventFunction] ADD CONSTRAINT [FK_CartEventFunction_CartEvent] FOREIGN KEY ([CartEventID]) REFERENCES [dbo].[CartEvent] ([CartEventID]) ON DELETE CASCADE ON UPDATE CASCADE
GO